+ Reply to Thread
Results 1 to 8 of 8

Help Needed with Strings

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Help Needed with Strings

    Dear friends,

    This forum is my last option.

    I currently have this (please look at the image):
    qqq.png

    So, I have "abbreviate /ə′bri:vıeıt/ v [T] qisqartirmoq – abbreviation /əˌbri:vı′ʃn / n [C] qisqartma, qisqartma shakl" all in one cell.

    I want to divide this into four columns like this:

    abbreviate | /ə′bri:vıeıt/ | v | [T] qisqartirmoq – abbreviation /əˌbri:vı′ʃn / n [C] qisqartma, qisqartma shakl

    qqq2.png

    As you can see this is a dictionary and I need to do separate each line into 4 cells. 1st - the word, 2nd - the pronunciation, 3rd - parts of speech (v., adj., n., pron., adv,. prep.), 4th - the rest of the line/string. So I can import it into dictionary editing software.

    Is this possible? can anyone help me please?

    SAMPLE FILE: Attachment 263261
    Last edited by alan4068; 09-05-2013 at 05:18 PM. Reason: attachment added

  2. #2
    Registered User
    Join Date
    09-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Help Needed with Strings

    I have attached a sample excel file.

    dictionary.xlsx

  3. #3
    Forum Contributor
    Join Date
    05-08-2013
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    102

    Re: Help Needed with Strings

    I have two questions

    [1] I see the following parts of speech in your file: n, adj, and v. Can I assume that you will have adverbs also? For example, in your file, you have the word "absolutely". However, that word does not appear to have the expected part of speech (i.e., adverb) shown. If so, should the abbreviation be "adv"?

    [2] What other parts of speech do you expect to have, and what abbreviations will you use? Will you have pronouns, prepositions, etc.? Knowing this will help us in pointing you in the right direction (if not outright writing the code). Please list out all such parts and their abbreviation. Upload an Excel file that contains an example for every part of speech you expect to encounter.

  4. #4
    Registered User
    Join Date
    09-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Help Needed with Strings

    Hi Dimitrov,

    Thank you for your reply.

    We only have n, adj, v, adv, prep,

    Please find attached file.Dict2.xlsx

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Help Needed with Strings

    Hi and welcome to the forum

    THis is not totally exact, it works well for the 1st 3 columns, but because there is some inconsistency in the begining of the 4th part (some have a -, others have a comma, others have none, and there may be some I have not yet seen). Give it a shot and let me know.

    B1=LEFT(A1,SEARCH("/",A1,1)-2)
    C1=MID(A1,SEARCH("/",A1,1)+1,SEARCH("/",A1,SEARCH("/",A1,1)+1)+1-(SEARCH("/",A1,1)+2))
    D1=MID(A1,SEARCH(C1,A1,1)+LEN(C1)+2,IF(OR(ISNUMBER(SEARCH("/ n",A1,1)),ISNUMBER(SEARCH("/ v",A1,1))),1,IF(OR(ISNUMBER(SEARCH("/ adj",A1,1)),ISNUMBER(SEARCH("/ adv",A1,1))),3,3)))
    E1=MID(A1,SEARCH("/ "&D1,A1,1)+LEN(D1)+2,99)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Forum Contributor
    Join Date
    05-08-2013
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    102

    Re: Help Needed with Strings

    alan4068

    Please see the attached spreadsheet. There is a macro on there called "ParseWords". Run that macro. Do not run the "Prepositions" macro, since it is called by the "Passwords" macro.

    Version02.xlsm.

    Hope this helps.

    ______________
    1. Mark this thread [SOLVED] if this solved your question.
    2. If this response helped you, click the star in the lower left of this response.
    Last edited by Dimitrov; 09-06-2013 at 01:50 AM.

  7. #7
    Registered User
    Join Date
    09-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Help Needed with Strings

    Dear dmitrov, it helped me. Only for the file you've sent.
    However when I wanted to run the macros on full list,

    it gave me the following error. (See attached)qqq3.png

  8. #8
    Forum Contributor
    Join Date
    05-08-2013
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    102

    Re: Help Needed with Strings

    alan4068,

    Can you please upload your full list? I would like to see if there are features in the full list that are causing the macro not to work, i.e., features that do not show up in the initial file you posted. It would help me determine how to proceed, or if it is beyond my skill level.
    Last edited by Dimitrov; 09-06-2013 at 04:01 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-13-2013, 08:32 AM
  2. Replies: 2
    Last Post: 03-07-2013, 02:34 AM
  3. Replies: 9
    Last Post: 12-21-2012, 04:18 AM
  4. Replies: 5
    Last Post: 02-15-2012, 09:57 AM
  5. Replies: 3
    Last Post: 05-28-2011, 01:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1