+ Reply to Thread
Results 1 to 4 of 4

Using Text.Position, but don't understand the result I'm getting back

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    201

    Using Text.Position, but don't understand the result I'm getting back

    Hi,
    I've been trying to use 'Text.PositionOf' to count the occurance of commas , but I don't I don't see what's happening,

    < Table.AddColumn(Source, "TextPosition", each Text.PositionOf([Category],",",Occurrence.All)) >


    I get a list back but it doesn't return what I would expect ie if the the first comma is the second character then '1'
    if the second is the 5th then '4'.


    but for the the sequence ; a , a , b , c , d results in ; i get a list ; 2,6,10,14

    I have looked at the Microsoft DOCS for M but didn't find it much help.

    Please find very small workbook attached.

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,047

    Re: Using Text.Position, but don't understand the result I'm getting back

    Power Query count start from 0


    a , a , b , c , d
    012345678901234567


    2,6,10,14

    0 a
    1 space
    2 1st comma
    3 space
    4 a
    5 space
    6 2nd comma
    7 space
    8 b
    9 space
    10 3rd comma
    Last edited by Bo_Ry; 04-23-2022 at 12:41 AM.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    201

    Re: Using Text.Position, but don't understand the result I'm getting back

    Sorry I'm not with you? I know pq counts from zero, so surely in: a , a , b , c , d , the first comma is in the second position, so '1',
    the second comma is in the 4th position so '3' the 5 and 7?
    Really confused. Oh, I have to go out so if you reply , I won't be able to respond until tomorrow, not ignoring you.

    Richard.

  4. #4
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    201

    Re: Using Text.Position, but don't understand the result I'm getting back

    Yes,
    Thanks, the penny did finally drop after I'd messaged you.
    I'll mark this closed and thanks for the help.

    Richard.

+ 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. Result coming back as text not a number.....maybe?
    By bob0613282 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-29-2017, 11:48 AM
  2. I don't understand SUMPRODUCT formula result
    By Dark0Prince in forum Excel General
    Replies: 4
    Last Post: 02-17-2017, 06:39 PM
  3. [SOLVED] Scroll window back to its original position
    By Tony Valko in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2016, 12:23 PM
  4. Replies: 4
    Last Post: 12-20-2012, 04:33 AM
  5. Index Match question........dont understand this result
    By welchs101 in forum Excel General
    Replies: 3
    Last Post: 11-17-2011, 10:52 AM
  6. can understand the result of a MID&FIND
    By carsto in forum Excel General
    Replies: 3
    Last Post: 12-22-2006, 08:07 PM
  7. Short cut to move back to last position
    By seane in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 04:25 AM

Tags for this Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.08638 seconds
  • Memory Usage 8,963KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (3)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (4)postbit_legacy
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1