Pdi

[marabu]

Of course, the data can be extracted using the Text file input step, as long as it has a documented structure.
And the content encoding US-ASCII is understood, too, even though the encoding seems to be pure ASCII.

A sample file is shared by the original poster.

[bysanees]

Marabu, thanks for quick reply
I have seen the files shared by the poster. What is the structure it should have to be called a structured ASCII file.
I just want understand if the text file input can parse/convert an ASCII file, if yes, what needs to be the structure of that file .
As per my understanding, the text file input might not convert the ASCII encoded file to a text file unless we define the correct encoding type.
Please advice

[marabu]

Structered text files wrt the Text file input (TFI) step are delimited text files (CSV) and fixed length text files (FIXED).
TFI requires the input file to be either CSV or FIXED, with each row having the same structure.

As I can see, the sample file has record types (A, B, C) indicated on the first position of each row.
Therefore a TFI step will be necessary for each and every record type. The type can be confugured through a filter.

TFI can extract data from text files with any supported encoding.
No need to support ASCII for input files directly, since ASCII is a proper subset of US-ASCII or even UTF-8.

[bysanees]

Here is the structured ASCII file using the meta data . The meta data explains the fixed length definitions.
Using the TFI, I have restructured this ASCII file, and this is the output I get.
Now, can I convert this ASCII code to text ? May be with the use of a value mapper/an ASCII table definition ?
PFA structured ASCII file: fixed length

[Mick_data]

Hi.
I think that there is a bit of confusion with teh terminology.. or maybe I am confused!

You do not convert ASCII to TEXT, because text files can be ASCII or UNICODE etc..
Basically ASCII is a characteristic (kind of) of a Text file.

Maybe you want to know how to convert a delimited text file to a Fixed length text file?
Or do you want to convert a ASCII text file to a UNICODE text file?

Mick

[marabu]

I am confused!

Me too.

I really didn't see that coming...