String manupulation

  • Thread starter Thread starter Serg
  • Start date Start date
S

Serg

Hi people,

how do I break out the following string into two columns:
Table:
Microsoft Windows 95 B
Microsoft Windows 95 C
Microsoft Windows NT Advanced Server 4.0
Microsoft Windows NT Workstation 5.1
Microsoft Windows 2000 Professional
Microsoft Windows XP Pro
break INTO:
_____column1___________|_____column2__________
Microsoft Windows 95 | B
Microsoft Windows 95 | C
Microsoft Windows NT | Advanced Server 4.0
Microsoft Windows NT | Workstation 5.1
Microsoft Windows 2000 | Professional
Microsoft Windows XP | Pro

Thanks a lot for the help,
 
You might TRY the following untested expressions. Notice that I start checking
for a space beginning with character 19 in the Instr expression.

Trim(Left(TheString,InStr(19,TheString," ")))
Trim(Mid(TheString,InStr(19,TheString," ")))
 
Thank you John again,
I will apply the functions and will let know if it work!
Thanks again,
Serg
 
John,
the expression does the job!
Thank you,
Serg
-----Original Message-----
Thank you John again,
I will apply the functions and will let know if it work!
Thanks again,
Serg Notice
that I start checking
.
Click to expand...
 
Back
Top