How to Import Specific Pattern of Data.

Ask a Question

Hi All,

I am Importing the Data from Text File. The Issue is this Particular Fields Say Item Code it has two patterns of Data.

Pattern A: 3040-403-R1123-40

Pattern B: 3040403R1123 40.

In the Script when I am Importing as Follows:

@252:271T AS [Item Code], I cant Mention Maxstring as the Pattern B makes up with spaces for the Special Characters Spaces.

My question is what condition should I use so that the Data only of the Pattern B is Imported ?

Any Help will be appreciated.

Thanks,

Madu

0 Replies