Re: String manupulation
From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 08/30/04
- Next message: John Spencer (MVP): "Re: Action queries changing when reopened in design view"
- Previous message: Hugh: "Re: Date"
- In reply to: Serg: "String manupulation"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 18:58:09 -0400
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," ")))
Serg wrote:
>
> 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,
- Next message: John Spencer (MVP): "Re: Action queries changing when reopened in design view"
- Previous message: Hugh: "Re: Date"
- In reply to: Serg: "String manupulation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
