Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

acccess query split text to ...

Hello all,

There is column like this in a table :

Item |Type
I1    | 78 lbs

Now I want to do query that splits the above type to two display  columns like this:
Item | size | size denomination
I1  |  78    | lbs
1
Rayne
Asked:
Rayne
  • 7
  • 3
1 Solution
 
RayneAuthor Commented:
thank you
0
 
danishaniCommented:
Try this in a Query:
size: Left([YourFieldName],InStr(1,[YourFieldName]," ")-1)
size denomination: Right(Trim([YourFieldName]),Len(Trim([YourFieldName]))-InStr(1, _
 [YourFieldName]," "))

Make sure you change [YourFieldName] into the actual column name you want to change, for example [Type] if that's the column name.
0
 
RayneAuthor Commented:
This piece is not working
InStr(1,[YourFieldName]," ")-1)

returning function error
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
RayneAuthor Commented:
it works :)
thank you
0
 
RayneAuthor Commented:
I am getting #Func! as error for some rows for size. How to check it> do you know...
0
 
RayneAuthor Commented:
ding dong - any solution? do i need to re-open this question? for this
0
 
danishaniCommented:
Hi Rayne,
Please post the value which give you the error.
I guess some of the content does not match the logic to split the fields correctly.

Thanks,
Daniel
0
 
RayneAuthor Commented:
thank danishani, I sorted it. Used iif
Cheers :)
0
 
danishaniCommented:
Perfect glad you got it working! :)
0
 
Love ChopraDeveloperCommented:
Its working for me too. Thx
0
 
RayneAuthor Commented:
@love Chopra
this is my fevorite life saver forum. Saved me several nights of coffee several times
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now