Read_delimited()- Required Column Missing

ray.wurlod · Post by **ray.wurlod** » Thu Nov 02, 2006 3:28 pm

Look at the Missing Column property. It's in the Columns grid.

thumsup9 · Post by **thumsup9** » Thu Nov 02, 2006 3:53 pm

You can use 'Replace' in the Incomplete Column grid.

shilpa79 · Post by **shilpa79** » Thu Nov 02, 2006 4:10 pm

Its working fine.

Thank you so much for all your help.

Shilpa.

pradkumar · Post by **pradkumar** » Wed Nov 08, 2006 3:11 pm

Hi

I want to detach the code which is at end of each record into separte column "alt_text" and palce at the end of record. The output should look like

OUTPUT :
CODE | TEXT|.... |ALT_TEXT (=TEXT)
470E | HYD!3721|...|HYD!3721
471E|HYD!3722|.....|HYD!3722
How to do this?

My job is something like seq -> transformer->table

I_Server_Whale · Post by **I_Server_Whale** » Wed Nov 08, 2006 3:14 pm

This is a THREAD HIJACK. You have already posted this topic in an earlier post.

If you are not an author of a post, I guess you cannot "re-open" it either.

Please DO NOT post twice. This will not take you very far in getting answers.

Whale.

DeepakCorning · Post by **DeepakCorning** » Wed Nov 08, 2006 3:16 pm

You can always have a seperate column defined at the target level rather than declaring at the source level so ur mapping in short will look like -->

Column1 -- Column1
Column2 -- Column2
-- Column3 assigne Column 2

shilpa79 · Post by **shilpa79** » Wed Nov 08, 2006 3:34 pm

Delimited Substrings is the one You can extract using this syntax:

string [ delimiter, instance, fields ]

string is the string containing the substring.

delimiter specifies the character that delimits the substring.

instance specifies the instance of delimiter where the extraction is to start.

fields specifies the number of fields to extract.

you can also use field function 'field'
Field (string, delimiter, instance [ ,number] )

pradkumar · Post by **pradkumar** » Wed Nov 08, 2006 3:57 pm

Hello Whale

I posted it as it is related to the previous discusion.
By the way I am new to group and I really donot know that, this should not be done. I am sorry about it and will not repeat it in future

suresh.narasimha · Post by **suresh.narasimha** » Fri Nov 10, 2006 12:14 am

Hi Shilpa,

This looks like your source data problem.

If you are not worried about extra columns in the record you can check The option in format tab - Suppress row truncation warnings.

Else you open the file in a textpad or edit plus to trace the error record manually.

Regards,

DSXchange

Read_delimited()- Required Column Missing

Hi,

Read_delimited