Read_delimited()- Required Column Missing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 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
Pradeep Kumar
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
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.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Hi,
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] )
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] )
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Read_delimited
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,
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,
SURESH NARASIMHA