Skip to Content
0
Former Member
May 17, 2010 at 11:11 AM

Sender Side: File Content Conversion

102 Views

I have a text file, with following values.

AAA056070144AEA056070144AACTESTPO271+(.......sequence continues)

Length of TAG (Like AAA, AEA,AAC etc) is fixed (i.e.3 ). Length of the Values coming after TAG are not fixed. Field Separator is '+'.

Source structure is

DT_OrdersFromECHO

|_ ECHO_SO

|_ Value

My requirement is after FCC, I sud get

ECHO_SO

|_ Value : AAA056070144

ECHO_SO

|_ Value : AEA056070144

ECHO_SO

|_ Value : AACTESTPO271

If I mention field Separator and filed Names ,it gives an error

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR converting document line no. 1 according to structure 'ECHO_SO':java.lang.Exception: ERROR in configuration / structure 'ECHO_SO.': More elements in file csv structure than field names specified!

How can i achieve it?