Field Separator as Space

[Former Member]

Hi Sdners,

My interface is Idoc to Flat file. I am facing a problem when I am doing content conversion for receiver communication channel.

My receiver structure is

abc 123 xyz

def 456 xyz

ghi 567 xyz

For me field separator is space. Can anybody suggest, what I have to give as field separator if space comes.

Regards

Jayaram.G

[jyothi_anagani · Accepted solution]

Hi,

You have 2 ways to do this.

one is Take HexaDecimalValue of space and use that as fielSeparator.

Secondway is While mapping replace space with ,(comma) and use fielSeparator as , in ContentConversion.

Thanks.

[Former Member · Accepted solution]

Thanks for your quick reply.......

Hi Vijay,

I tried by copying space from notepad and pasted in content conversion. But when I saved and activated my communication channel, it is not showing any space. Can you please help me out from this problem.

Hi Jyothi,

If possible can you provide hexadecimal code for field separator as space.

Thanks in advance.

Regards,

Jayaram.

[former_member750652 · Accepted solution]

Hi Jayaram,

Canyou try with ' ' (single quote, space, single quote ) for field seperator.I think this also works.

Thanks,

Ram.

[jyothi_anagani · Accepted solution]

Hi,

Hx for Space is 20 and try giving fieldSeparator as ' ' (space in single quoute).

Thanks.

[Shabarish_Nair · Accepted solution]

>

> 
>          If possible can you provide hexadecimal code for field separator as space.
> 
>          Thanks in advance.
> 
> Regards,
> Jayaram.

http://www.ascii.cl/htmlcodes.htm

[former_member184619 · Accepted solution]

Hi Jayaram,

Try using 0x20 for the space

Sachin

[Former Member]

Hi,

Sory It's for Tab only ...

Use 0x09. I'm sure it works If not then use it with sngle quotes '0x09'

For Space use 0x20

Sameer!

Edited by: sameer Khanna on Apr 21, 2009 2:12 PM

[Shabarish_Nair]

type a space in notepad and copy the space to your FCC parameters - similar to what i have done for TAB in this blog - /people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

[Former Member]

This message was moderated.