I Have a table with the following fields:
(in PIPE delimited test)
EPIC |NDC |Brand |Generic |Price |FIELD006
3697646|378061401| | | |Tot $: 5.52
3697646|378061401| | | |Tot Vol: 1
3697646|378061401| | |Curr $: 5.52|
3697646|378061401|THIORID|THIORIDAZINE| |
1.I have used breakapart array to parse Price field, but cant get link to records (it parses the field and lists them unattached to a record)
2. I needed to insert ( fill() ) leading zeros into NDC field (to make compatable with another DB).
Tkanks in advance
(in PIPE delimited test)
EPIC |NDC |Brand |Generic |Price |FIELD006
3697646|378061401| | | |Tot $: 5.52
3697646|378061401| | | |Tot Vol: 1
3697646|378061401| | |Curr $: 5.52|
3697646|378061401|THIORID|THIORIDAZINE| |
1.I have used breakapart array to parse Price field, but cant get link to records (it parses the field and lists them unattached to a record)
2. I needed to insert ( fill() ) leading zeros into NDC field (to make compatable with another DB).
Tkanks in advance