Skip to Content
avatar image
Former Member

what is the field separtor for space bar in fcc conversion

Hello All,

What is the filed separator for space abr between fields, traied with 0x09, ' ', and '' ''.

i copied space bar space from note pad also. but it not working.

could you please help me what is field separator for space bar.

Thanks and Regards,

s.prabhakar.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 30, 2016 at 05:00 AM

    Hello Prabhakar,

    Try using

    0x20 or '0x20'

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi raghuraman,

      That is for tab delimeter right, i used that one also but not working.

      my file like

      abc 123 xyz

      sdf 567 bgh

      is it any data types we need to change in data types, i am using type is xsd: string.

      help me.

      thnaks,

      s.prabhakr.

  • Nov 30, 2016 at 05:21 AM

    can you post the FCC parameters screenshot.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I push one file with 104 charecters, but i got output as 248 charecters.

      is it counting space also between fileds and rows.

      if it will count how can i remove the space charecters count.

      Thanks,

      s.k.prabhakar

  • Nov 30, 2016 at 07:09 AM

    Hi Prabhakar!

    As Raghu has already said, '0x20' is the value of "fieldSeparator" parameter in case of space-delimeted file.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2016 at 04:52 AM

    Hi Prabhakar!

    I will ask the same question again: what's your aim? Since you work with PI environment you deal with interfaces, messages, data types. What will you do with results of your counting? Do you need to include that result to target message?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded