What is the Field separator value for '=' sign in FCC?

[Former Member]

Hi Experts,

What is the Field separator value for '=' sign in FCC?

For example the file content is as follows:

ABC=XX:15013546094667:Text PL3:

CDX=1+ORDHDR:9'

VVV=0470+ORDER9'

TTT=5014379000007+'

CCC=Solihull:West Midlands::B90 4LE'

Thanks a lot for ur help

Tush

[Former Member · Accepted solution]

Hi Tush,

You can use <recordset name>.fieldSeparator = '0x3D'

Prerequisite:

In the text given below:

ABC=XX:15013546094667:Text PL3:

ABC and the remaining XX:15013546094667:Text PL3: should be in two different fields.

Or atleast 'ABC' and 'XX' , as we need to insert a field separator between them.

Thanks,

Varun

[sunil_singh13]

Hi Tushi,

It Seems like your starting three characters are of same length

(If it is true) then you can use fixedLength Conversion to meet your requirement .

Reward Points if Helpful

Thanks

Sunil Singh

[Former Member]

try with this for '='

'0x3D' (including the quotation marks)

[Former Member]

Thanks a lot. Solved with '0x3D'

[Former Member]

hi,

You can use = to indicate that = is field separator

or

Also try using 0x3D.

Regards

Ramesh P

[Former Member]

Hi,

ABC=XX:15013546094667:Text PL3:

In the above line, are ABC and XX:15013546094667:Text PL3: two different fields??

Can you please paste in you data type here..

Regards,

Manjusha.

[Former Member]

Hi Manjusha,

DT is as follows:

1st level --DT

-

---

Recordset

-

---

Records

-

---

Line_identifier

-

---

Data

That is, Line_Identifier = 'ABC' and Data = '

XX:15013546094667:Text PL3:'

thanks a lot.

Hi Ramesh,

I have tried with Records.fieldSeparator = '='. This is not working

Thanks a lot.

Best regards,

Tush

[Former Member]

Hi

Try with "0x3D"

[Former Member]

Hi Tush,

Use Recors.fieldSeparator = '0x3D'

I hope it should work.

Thanks,

Varun