J jlabre01 Registered User. Local time Today, 06:50 Joined May 26, 2008 Messages 62 May 28, 2008 #1 Hi, I just need to know how to parse to string/text format? jlabre01
KenHigg Registered User Local time Today, 06:50 Joined Jun 9, 2004 Messages 13,327 May 28, 2008 #2 In MS Access help look up the right() left() and mid() functions.
MSAccessRookie AWF VIP Local time Today, 06:50 Joined May 2, 2008 Messages 3,428 May 28, 2008 #3 two more good functions KenHigg said: In MS Access help look up the right() left() and mid() functions. Click to expand... If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String)
two more good functions KenHigg said: In MS Access help look up the right() left() and mid() functions. Click to expand... If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String)
KenHigg Registered User Local time Today, 06:50 Joined Jun 9, 2004 Messages 13,327 May 28, 2008 #4 Forgot those -
boblarson Smeghead Local time Today, 03:50 Joined Jan 12, 2001 Messages 32,059 May 28, 2008 #5 MSAccessRookie said: If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String) Click to expand... I'll throw out one more good one to know: InstrRev(StringToCheck As String, StringToMatch As String, Optional Start As Long, Optional Compare As VbCompareMethod)
MSAccessRookie said: If you are going to parse, then two more good functions to know would be InStr(Start, String1, String2) and Len(String) Click to expand... I'll throw out one more good one to know: InstrRev(StringToCheck As String, StringToMatch As String, Optional Start As Long, Optional Compare As VbCompareMethod)
J jlabre01 Registered User. Local time Today, 06:50 Joined May 26, 2008 Messages 62 May 28, 2008 #6 Thanks to all, I got it to work jlabre01